package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_CompoundPrimary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundPrimary(columns = {"WECHAT_APPID", "WECHAT_OPENID"})
@_DDL_Table(name = "user_wechat_info", simpleName = "", engine = MysqlDriver.InnoDB, comment = "用户微信信息")
public class _DDL_UserWechatInfo {

    @_DDL_Column(name = "USER_ID", type = SqlType.INT, nullable = false, comment = "用户ID")
    private Integer userId;

    @_DDL_Column(name = "WECHAT_PHONE", type = SqlType.VARCHAR, size = 15, comment = "微信用户手机号")
    private String wechatPhone;

    @_DDL_Column(name = "WECHAT_OPENID", type = SqlType.VARCHAR, size = 35, nullable = false, comment = "微信用户标识")
    private String wechatOpenid;

    @_DDL_Column(name = "WECHAT_UNIONID", type = SqlType.VARCHAR, size = 35, nullable = false, comment = "微信用户唯一标识")
    private String wechatUnionid;

    @_DDL_Column(name = "WECHAT_SESSION_KEY", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "微信会话KEY")
    private String wechatSessionKey;

    @_DDL_Column(name = "WECHAT_APPID", type = SqlType.VARCHAR, size = 35, nullable = false, comment = "微信应用ID")
    private String wechatAppid;

    @_DDL_Column(name = "CREATE_TIME", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp createTime;

    @_DDL_Column(name = "UPDATE_TIME", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP_ON_UPDATE, comment = "更新时间")
    private java.sql.Timestamp updateTime;

    @_DDL_Column(name = "WECHAT_PHONE_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "微信用户手机号密文")
    private String wechatPhoneCiphertext;

    @_DDL_Column(name = "WECHAT_NICK_NAME", type = SqlType.VARCHAR, size = 50, comment = "微信昵称")
    private String wechatNickName;

    @_DDL_Column(name = "WECHAT_AVATAR_URL", type = SqlType.VARCHAR, size = 255, comment = "微信头像地址")
    private String wechatAvatarUrl;

}
